﻿/*****************************************************************************/
/*****************************************************************************/
CREATE PROCEDURE [CaseManagement].[InjuriesForCase]( @CaseOID BIGINT )
AS  
BEGIN

	Select  Injuries.OID as 'InjuryOID',
            Injuries.Version as 'InjuryVersion',
            Injuries.CaseID as 'InjuryCaseID',
            Injuries.InjuryID,
            TypesOfInjury.Description as 'InjuryDescription',
            Injuries.UpdatedDate as 'InjuryUpdatedDate',
            Injuries.CreatedDate as 'InjuryCreatedDate'
	From Injuries
	Left Join TypesOfInjury On TypesOfInjury.OID = Injuries.InjuryID
	Where
		Injuries.CaseID = @CaseOID

END


